package com.ele.Dao;

import com.ele.Pojo.Employee;

import java.sql.SQLException;
import java.util.List;

public interface EmployeeDao {
    /**
     * 查找Employee表中全部信息
     */
    public List<Employee> getAll() throws SQLException;
    /**
     * 查部分
     */
    public List<Employee> query(String account,String telephone,String nickname) throws SQLException;


    /**
     * 添加员工
     */
    public Integer addEmp(Employee emp) throws SQLException;

    /**
     * 修改员工
     */
    public Integer update(Employee emp) throws SQLException;
    /**
     * 删除员工
     */
    public Integer delete(String id) throws SQLException;

    /**
     * 员工登录
     * @param account
     * @param password
     * @return
     */
    Employee empLogin(String account, String password)throws SQLException;

}
